﻿CREATE TABLE [dbo].[CIMbankinfo]
(
[aid] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[bankname] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL,
[bankid] [smallint] NULL,
[firstpay] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[cactive] [float] NULL,
[loanSum] [float] NULL,
[percentage] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[loanTerm] [smallint] NULL,
[loanFrom] [datetime] NULL,
[loanTo] [datetime] NULL,
[loanType] [bit] NULL,
[getloanDate] [datetime] NULL,
[bail] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[notarDate] [datetime] NULL,
[agrIdLoan] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[agrIdPle] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[agrIdNotar] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[agrIdImpawn] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[activeFloat] [float] NULL
) ON [PRIMARY]


